<?php
/**
 * crcl/base
 *
 * Copyright 2013 CRCL - André Sabosch - info@crcl.de
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

namespace crcl\base\database\query\traits;

trait Join
{
  public function setJoin($sTable, $sType = 'inner')
  {
    $this->aJoin = array('table' => $sTable, 'type' => $sType);
    return $this;
  }

  public function setOn($sLeft, $sRight, $sOperator = '=')
  {
    $sOperator = \trim($sOperator);
    $sLeft =  $this->aTables[0] . '.' . $sLeft;
    $sRight = $this->aJoin['table'] . '.' . $sRight;
    $this->aJoin['condition'] = $sLeft . ' ' . $sOperator . ' ' . $sRight;
    return $this;
  }

  public function setOnCondition($sCondition)
  {
    $this->aJoin['condition'] = $sCondition;
    return $this;
  }

  public function getJoin()
  {
    return $this->aJoin;
  }

  /** PROTECTED ***********************************************************************************/

  protected $aJoin = array();
}
